package com.koron.css2.clientCenter.mapper;

import com.koron.css2.clientCenter.bean.ChangeUserImportBean;
import com.koron.css2.clientCenter.bean.ChangeUserImportDetailBean;
import com.koron.css2.clientCenter.bean.UserChangeItemBean;
import com.koron.css2.clientCenter.bean.UserGroupBean;
import com.koron.css2.clientCenter.queryBean.ChangeUserImportQueryBean;
import com.koron.css2.clientCenter.queryBean.ChangeUserItemsQueryBean;
import com.koron.css2.clientCenter.vo.ChangeUserImportVo;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface ChangeUserImportMapper {
	int addBill(ChangeUserImportBean bean);
	int addDetail(List<ChangeUserImportDetailBean> list);
	List<ChangeUserImportVo> selectList(ChangeUserImportQueryBean bean);
	ChangeUserImportVo getBillByid(@Param("id")String id);
	List<UserChangeItemBean> getChangeItems(@Param("query")ChangeUserItemsQueryBean query,@Param("temp")int temp);
	
	
	List<ChangeUserImportDetailBean> selectListDetail(@Param("id")String id);
	//审批后续执行，修改正式表数据
	Integer workflowEndUpdateUserInfo(@Param("id")String id);
	Integer workflowEndUpdateCtmInfo(@Param("id")String id);
	Integer workflowEndUpdateAccountInfo(@Param("id")String id);
	Integer deleteDetail(@Param("id")String id);
	Integer delete(@Param("id")String id);
	
	Integer updateBillDetailCtmName(@Param("id")String id,@Param("accountPeriod")String accountPeriod);
	
	
	List<UserChangeItemBean> selectChangeItem(@Param("id")String id);
	/**
	 * 还原批量变更
	 */
	Integer restoreChangeImport(@Param("userNo")String userNo,@Param("sql")String sql);
	/**
	 * 获取批量变更的用户组
	 */
	List<UserGroupBean> selectGroupNo(@Param("id")String id);
}
